SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_GetGwyNewsByID] ( @JOL_GWY_News_ID INT )
AS 
    SELECT  b.JOL_Employer_Name,
            a.JOL_GWY_NewsTitle,
            a.JOL_GWY_NewsBody,
            a.JOL_GWY_ApplyMethod,
            a.JOL_GWY_NewsClick,
            a.JOL_GWY_AddTime,
            a.JOL_GWY_AddUser,
            a.JOL_GWY_UpdateTime,
            a.JOL_GWY_UpdateUser
    FROM    dbo.JOL_GWY_News AS a
            INNER JOIN dbo.JOL_Employer AS b ON a.JOL_EmployerName = b.JOL_Employer_Account
    WHERE   JOL_GWY_News_ID = @JOL_GWY_News_ID
GO
